www.loanperformer.com

Table of Contents (Online Help)

Group Members Outstanding Balances

The Group Members Outstanding Balances Report gives details of the loans that are still pending payment up to the date selected.

To get to this screen, you go to menu Loans/Portfolio Reports/Group Members Portfolio Reports/Group Members Outstanding Balances. You will see a screen that looks as follows.

• Reporting Date: Enter the date as at which you would like to generate a report. In the screen above, we want a report as at 21/03/2018.
• Exclude expired loans: When this option is checked, the report generated will exclude those loans whose maturity date of repayment has passed e.g. if loan repayments of 1,000 to Peter were to be fully paid by 12th November 2016 but has not been repaid; then basing on the reporting date selected above, this loan will not appear in the report.
• From Loan No:  Enter the loan number for which the Loan Amounts per Group Member report should start, e.g., "KA00005" and in the "To" section enter the loan number for which the report will stop, e.g., "KA00017" as seen in the screen above. This will show all Loan amounts due by group members for the selected range of loan numbers.
• Branch Code: Select a branch for which you want to generate a report. In the example above, we have checked "For all" option to have a report for all branches. In case you are using a Demo Database, then the default will be DB from the options in the drop down box.
• Credit Officer:  Select from the drop down box a particular credit officer whom you want to generate a report about, this may be to see the Group Members Outstanding Balances for loans handled by the credit officer selected. In the example, the "For all" option is checked.
• Loan Fund: From the drop down box, select a particular Loan Fund that you want to generate a Group Members Outstanding Balances report. This is in order to find out how much money is due into a particular fund that was utilised for the selected period of time. The Loan Fund is set at Menu System/Configuration/Funds. In the example, the "For all" option is checked, this is in order to have a Group Members Outstanding Balances report on all Funds that are available in the system.
• Geographical Area: From the drop down box, you can select a particular area/location/region of which you would like to generate a Group Members Outstanding Balances report about. It may be a town, City as specified in your settings under Menu Support Files/Geographical Area's. In the example above, the "For all" option is selected in order to have a Group Members Outstanding Balances report on clients from all geographical areas available in the system.
• Loan Product: From the drop down box, select a loan Product that you want to generate a report about. The Loan product depends on what was set at Menu System/Configuration/Products. You may have Loan Products like School Fees Loans, Agricultural Loans etc. In the example above, the "For all" option is selected in order to have a report on Group Members Outstanding Balances from all Loan Products available in the system.
• Business Sector: From the drop down box, select a business sector from which you want to generate a report about. This can be Agriculture, Industry, Services or any other depending on what you set at Menu Support files/Business Sector. In the example above, the "For all" option is selected to have a report on Group Members Outstanding Balances from all sectors that were granted loans in the selected period.
• Grouping/Order: Select from the drop down box how the report to be generated will be classified in the column title/heading. In the example above, Group by Client Name is selected.
• Report Format: Select from the drop down box the sequence in which the column titles in your report will appear.
• Member Category 1:  Select a particular category of group members from the drop down box or check "For All" option to have Group Members Outstanding Balances report for all the categories of group members available in the system.  Member Category is set at menu Support Files/Group Member Category 1. This applies to member category 2 and 3.
• Client Category 1: From the drop down box, select a client based on the classification that you made at Menu Support Files/Client Category 1. In the example, the "For all" option is checked. The same applies for Client Category 2 and client Category 3.
• Loan Category 1: From the drop down box, select a classification of a loan that you made at Menu Support Files/Loan Category 1, it may have been a long term loan, short term loan etc. In the example, the "For all" option is checked. The same applies for Loan Category 2 and Loan Category 3.

• Additional filtering options? : This option is used to get a particular field or specification that you want. It helps you to narrow down the search for information that you need. When you check this option and click ok, a pop up screen will appear. 

• In the pop up screen, select the required filter criteria from the drop down boxes e.g. SECTOR, relational operator, e.g., "=" (Equals sign) and the value e.g., "Agriculture".

• Click the OK button if all the data entered is sufficient. You will get another pop up information screen showing the filter for the Group Members Outstanding Balances report that was selected.  Click on Yes button if it is the right filter to generate the Group Members Outstanding Balances report.

• *When you do not select the additional filter option, we will continue with the details in the first screen and it will be as follows:

• Detail: Select this option when you want much information about the Group Members Outstanding balances for the selected period.
• Summary: When this option is selected the Group Members Outstanding Balances report will only show the total amount outstanding for all group members i.e. there will be no break down for each group member.
• View:  If you want to look at the soft copy of the Group Members Outstanding balances report, then this option should be selected.
• Print: If you want to look a hard copy (on paper) of the Group Members Outstanding balances report, then this option should be selected.
• Report PDF File Format: Select this option if the report to be generated is to be displayed in Portable Document File Format.
• Report XLS File Format: Select this option if the report to be generated is to be displayed in Excel File Format.
• Report DBF File Format: Select this option if the report to be generated is to be displayed in Database File format.
• Create Graph: Select this option if the report to be generated is to be displayed on a chart.
• Individual Loans Only: This option will not be active as the report to be generated is for group members.
• Group Loans Only: Select this option if the report to be generated is for only Group Member clients with outstanding balances.
• All Loans: This option will not be active as the report to be generated is for group members.
• All Pages: Check this option to print all pages of the Group Members Outstanding Balances report.
• Pages: You can select a specific range of pages to be printed for the Group Members Outstanding Balances report.

Contact LPF live support for more information
This service requires an Internet connection.